package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class JDBCDemo1 {
    public static void main(String[] args) throws Exception {
        Connection connection=DBUtil.getConnection();
        Statement statement = connection.createStatement();
        /*CREATE TABLE user(
            id INT PRIMARY KEY AUTO_INCREMENT,
            username VARCHAR(32),
            password VARCHAR(32),
            nickname VARCHAR(32),
            age INT(3)
        )
         */
        String sql="CREATE TABLE user(\n" +
                "            id INT PRIMARY KEY AUTO_INCREMENT,\n" +
                "            username VARCHAR(32),\n" +
                "            password VARCHAR(32),\n" +
                "            nickname VARCHAR(32),\n" +
                "            age INT(3)\n" +
                "        )";
        //返回的是有没有查询结果集
        statement.execute(sql);
        System.out.println("执行成功");
        connection.close();
    }
}
